CREATE TRIGGER [dbo].[TU_Stock] ON [dbo].[Stock] 
AFTER  UPDATE
AS
   Declare @Kala_Code Varchar(15)
  Declare @Anbar_Code Varchar(3)
  Declare @FirstCount Real
  Declare @SecondCount REAL
  Declare @FinalCount REAL
  

  Declare Cursor_Update cursor  For
  Select Kala_Code, Anbar_Code, FirstCount, SecondCount,FinalCount From Inserted
  Open Cursor_Update
  Fetch Next From  Cursor_Update Into @Kala_Code , @Anbar_Code, @FirstCount , @SecondCount,@FinalCount
  While @@Fetch_Status = 0 
   Begin
      IF Update(FinalCount) AND @FinalCount IS NOT NULL 
         Update Stock Set Flag = '2'  Where Kala_Code = @Kala_Code and  Anbar_Code = @Anbar_Code

     Else IF Update (SecondCount) AND @SecondCount IS NOT NULL
	 BEGIN 
      IF (@SecondCount = @FirstCount )   
         Update Stock Set Flag = '2', FinalCount = SecondCount  Where Kala_Code = @Kala_Code and  Anbar_Code = @Anbar_Code
      else    
         Update Stock Set Flag = '4'   Where Kala_Code = @Kala_Code and  Anbar_Code = @Anbar_Code
	END
    
	ELSE IF Update (FirstCount) AND @FirstCount IS NOT NULL 
      Update Stock Set Flag = '3'  Where Kala_Code = @Kala_Code and  Anbar_Code = @Anbar_Code	 
         
     Fetch Next From  Cursor_Update Into @Kala_Code , @Anbar_Code, @FirstCount , @SecondCount, @FinalCount
   End
 Close Cursor_Update
 Deallocate Cursor_Update